CREATE TABLE [dbo].[C_CUPS]
(
[cup] [numeric] (4, 0) NOT NULL,
[goalscore] [numeric] (2, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C_CUPS] ADD CONSTRAINT [ch_C_Cups_goal] CHECK (([goalscore]>(0)))
GO
ALTER TABLE [dbo].[C_CUPS] ADD CONSTRAINT [pk_C_Cups] PRIMARY KEY CLUSTERED  ([cup]) ON [PRIMARY]
GO
